Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

View
1) Adding ORDER BY to the Joined Table View
2) ALTER VIEW statement
3) Check Options
4) Create a view
5) Create a view in which the difference between the number of sets won and the number of sets lost are recorded
6) Create view and rename the backend column names
7) Create view for a date range
8) Create view for aggregate functions
9) Create view for user information
10) Create view WITH CASCADED CHECK OPTION
11) Create view with calculation
12) Create view with check option
13) Creating a view by joining two tables
14) Creating a View with Joined Tables
15) Creating a View with Specified Column Names
16) Creating a View with UNION
17) Creating an Updatable View
18) Creating Views
19) Defining Views of Views
20) DESCRIBE statement works on a view just as it does on a table
21) Removing Views
22) To view the current status variable settings, you can use the SHOW STATUS statement
23) Using a GROUP BY Clause to Create a View
24) Using a GROUP BY Clause to Create a View ALGORITHM = TEMPTABLE
25) Using EXPLAIN
26) Using HAVING with GROUP BY to Create a View
27) View with subquery
28) You can use the SHOW CREATE VIEW command to view the entire CREATE syntax used when creating a view